from sqlalchemy import Column
from sqlalchemy.sql.sqltypes import Integer, String, Text, TIMESTAMP
from sqlalchemy.ext.declarative import declarative_base

Base = declarative_base()

class DishonestHi(Base):
    __tablename__ = "TYC_HI_DISHONEST"
    INAME = Column(String(255))
    BUSINESSENTITY = Column(String(255))
    GISTID = Column(String(255))
    AREANAME = Column(String(255))
    CARDNUM = Column(String(255))
    COURTNAME = Column(String(255))
    PUBLISHDATE = Column(Integer)
    TYPE = Column(String(50))
    GISTUNIT = Column(String(255))
    DUTY = Column(String(4000))
    PERFORMANCE = Column(String(255))
    REGDATE = Column(Integer)
    CASECODE = Column(String(255))
    DISRUPTTYPENAME = Column(String(2000))

    ENTNAME = Column(String(100))
    PRIPID = Column(String(36))
    REGNO = Column(String(50))
    UNISCID = Column(String(18))
    CREATE_TIME = Column(TIMESTAMP)
    UPDATE_TIME = Column(TIMESTAMP)